/****** Object:  Stored Procedure dbo.asi_GetTransResponseStart    Script Date: 7/3/2003 4:58:03 PM ******/

CREATE  PROCEDURE [dbo].[asi_GetTransResponseStart]

@userKey uniqueidentifier,
@rangeBegin int output,
@rangeEnd int output

AS

DECLARE @newGuid as uniqueidentifier
declare @EveryoneFullControlAccessKey uniqueidentifier
select @EveryoneFullControlAccessKey = ParameterValue from SystemConfig
    where ParameterName = 'Security.Token.EveryoneFullControlAccessKey'

set @rangeBegin = 0
set @rangeEnd = 0

BEGIN TRAN

-- Get the ending value
SELECT    @rangeEnd =  max(TRANS_NUMBER)
FROM    Trans

-- Check to make sure the counter exists - create it if not
IF NOT EXISTS(SELECT 1 FROM SystemConfig WHERE ParameterName='TransResponseRangeStart')
BEGIN
    SELECT @newGuid = newid()
    INSERT SystemConfig (SystemConfigKey, ParameterName, ParameterValue, Description,
        OrganizationKey, SystemEntityKey, CreatedByUserKey, CreatedOn)
    VALUES(    @newGuid,
        'TransResponseRangeStart',
        CAST(@rangeEnd As nvarchar(100)),
        'Ending point in the Trans table already processed by response acquisition.',
        '00000000-0000-0000-0000-000000000000',
        NULL,
        @userKey,
        getdate())
END

-- Get the beginning value
SELECT    @rangeBegin = CAST(ParameterValue As int)
FROM    SystemConfig
WHERE    ParameterName = 'TransResponseRangeStart'

-- Set the ending value
UPDATE    SystemConfig
SET    ParameterValue = CAST(@rangeEnd As nvarchar(100))
WHERE    ParameterName = 'TransResponseRangeStart'

COMMIT TRAN

GO